package com.jk.mapper;

import com.jk.model.ProductBean;
import com.jk.model.WuliuBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Mapper
public interface CJQMapper {

    int getCount();

    int findcount(HashMap<String, Object> params);

    List<WuliuBean> findBookList(HashMap<String, Object> params);

    int findcount2(HashMap<String, Object> params);

    List<WuliuBean> findBookList2(HashMap<String, Object> params);

    void delUserById(Integer[] ids);

    void sendEmp(Integer id);
    @Select("select * from t_product where productState = 1")
    List<ProductBean> findProductListImg();


    @Select("select  tpo.*,tso.id as storeId from t_product tpo\n" +
            "left join t_store tso on tso.productId=tpo.id\n" +
            "where tpo.id=#{value}")
    List<Map> queryProductById(Integer id);
    @Select("select  tpo.*,tso.id as storeId from t_product tpo\n" +
            "left join t_store tso on tso.productId=tpo.id\n" +
            "where tpo.id=#{value}")
    List<Map> queryProductById2(Integer id);
}


